package com.lwlk.zdk.model.T;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TDisStaffExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TDisStaffExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNull() {
            addCriterion("staff_id is null");
            return (Criteria) this;
        }

        public Criteria andStaffIdIsNotNull() {
            addCriterion("staff_id is not null");
            return (Criteria) this;
        }

        public Criteria andStaffIdEqualTo(String value) {
            addCriterion("staff_id =", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotEqualTo(String value) {
            addCriterion("staff_id <>", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThan(String value) {
            addCriterion("staff_id >", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdGreaterThanOrEqualTo(String value) {
            addCriterion("staff_id >=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThan(String value) {
            addCriterion("staff_id <", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLessThanOrEqualTo(String value) {
            addCriterion("staff_id <=", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdLike(String value) {
            addCriterion("staff_id like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotLike(String value) {
            addCriterion("staff_id not like", value, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdIn(List<String> values) {
            addCriterion("staff_id in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotIn(List<String> values) {
            addCriterion("staff_id not in", values, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdBetween(String value1, String value2) {
            addCriterion("staff_id between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffIdNotBetween(String value1, String value2) {
            addCriterion("staff_id not between", value1, value2, "staffId");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNull() {
            addCriterion("staff_name is null");
            return (Criteria) this;
        }

        public Criteria andStaffNameIsNotNull() {
            addCriterion("staff_name is not null");
            return (Criteria) this;
        }

        public Criteria andStaffNameEqualTo(String value) {
            addCriterion("staff_name =", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotEqualTo(String value) {
            addCriterion("staff_name <>", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThan(String value) {
            addCriterion("staff_name >", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameGreaterThanOrEqualTo(String value) {
            addCriterion("staff_name >=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThan(String value) {
            addCriterion("staff_name <", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLessThanOrEqualTo(String value) {
            addCriterion("staff_name <=", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameLike(String value) {
            addCriterion("staff_name like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotLike(String value) {
            addCriterion("staff_name not like", value, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameIn(List<String> values) {
            addCriterion("staff_name in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotIn(List<String> values) {
            addCriterion("staff_name not in", values, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameBetween(String value1, String value2) {
            addCriterion("staff_name between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andStaffNameNotBetween(String value1, String value2) {
            addCriterion("staff_name not between", value1, value2, "staffName");
            return (Criteria) this;
        }

        public Criteria andSexIsNull() {
            addCriterion("sex is null");
            return (Criteria) this;
        }

        public Criteria andSexIsNotNull() {
            addCriterion("sex is not null");
            return (Criteria) this;
        }

        public Criteria andSexEqualTo(Integer value) {
            addCriterion("sex =", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotEqualTo(Integer value) {
            addCriterion("sex <>", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThan(Integer value) {
            addCriterion("sex >", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexGreaterThanOrEqualTo(Integer value) {
            addCriterion("sex >=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThan(Integer value) {
            addCriterion("sex <", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexLessThanOrEqualTo(Integer value) {
            addCriterion("sex <=", value, "sex");
            return (Criteria) this;
        }

        public Criteria andSexIn(List<Integer> values) {
            addCriterion("sex in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotIn(List<Integer> values) {
            addCriterion("sex not in", values, "sex");
            return (Criteria) this;
        }

        public Criteria andSexBetween(Integer value1, Integer value2) {
            addCriterion("sex between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andSexNotBetween(Integer value1, Integer value2) {
            addCriterion("sex not between", value1, value2, "sex");
            return (Criteria) this;
        }

        public Criteria andIdtypeIsNull() {
            addCriterion("idtype is null");
            return (Criteria) this;
        }

        public Criteria andIdtypeIsNotNull() {
            addCriterion("idtype is not null");
            return (Criteria) this;
        }

        public Criteria andIdtypeEqualTo(Integer value) {
            addCriterion("idtype =", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotEqualTo(Integer value) {
            addCriterion("idtype <>", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeGreaterThan(Integer value) {
            addCriterion("idtype >", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("idtype >=", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeLessThan(Integer value) {
            addCriterion("idtype <", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeLessThanOrEqualTo(Integer value) {
            addCriterion("idtype <=", value, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeIn(List<Integer> values) {
            addCriterion("idtype in", values, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotIn(List<Integer> values) {
            addCriterion("idtype not in", values, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeBetween(Integer value1, Integer value2) {
            addCriterion("idtype between", value1, value2, "idtype");
            return (Criteria) this;
        }

        public Criteria andIdtypeNotBetween(Integer value1, Integer value2) {
            addCriterion("idtype not between", value1, value2, "idtype");
            return (Criteria) this;
        }

        public Criteria andNationIsNull() {
            addCriterion("nation is null");
            return (Criteria) this;
        }

        public Criteria andNationIsNotNull() {
            addCriterion("nation is not null");
            return (Criteria) this;
        }

        public Criteria andNationEqualTo(String value) {
            addCriterion("nation =", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotEqualTo(String value) {
            addCriterion("nation <>", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThan(String value) {
            addCriterion("nation >", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationGreaterThanOrEqualTo(String value) {
            addCriterion("nation >=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThan(String value) {
            addCriterion("nation <", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLessThanOrEqualTo(String value) {
            addCriterion("nation <=", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationLike(String value) {
            addCriterion("nation like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotLike(String value) {
            addCriterion("nation not like", value, "nation");
            return (Criteria) this;
        }

        public Criteria andNationIn(List<String> values) {
            addCriterion("nation in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotIn(List<String> values) {
            addCriterion("nation not in", values, "nation");
            return (Criteria) this;
        }

        public Criteria andNationBetween(String value1, String value2) {
            addCriterion("nation between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andNationNotBetween(String value1, String value2) {
            addCriterion("nation not between", value1, value2, "nation");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNull() {
            addCriterion("telephone is null");
            return (Criteria) this;
        }

        public Criteria andTelephoneIsNotNull() {
            addCriterion("telephone is not null");
            return (Criteria) this;
        }

        public Criteria andTelephoneEqualTo(String value) {
            addCriterion("telephone =", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotEqualTo(String value) {
            addCriterion("telephone <>", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThan(String value) {
            addCriterion("telephone >", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneGreaterThanOrEqualTo(String value) {
            addCriterion("telephone >=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThan(String value) {
            addCriterion("telephone <", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLessThanOrEqualTo(String value) {
            addCriterion("telephone <=", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneLike(String value) {
            addCriterion("telephone like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotLike(String value) {
            addCriterion("telephone not like", value, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneIn(List<String> values) {
            addCriterion("telephone in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotIn(List<String> values) {
            addCriterion("telephone not in", values, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneBetween(String value1, String value2) {
            addCriterion("telephone between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andTelephoneNotBetween(String value1, String value2) {
            addCriterion("telephone not between", value1, value2, "telephone");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelIsNull() {
            addCriterion("cultural_level is null");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelIsNotNull() {
            addCriterion("cultural_level is not null");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelEqualTo(Integer value) {
            addCriterion("cultural_level =", value, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelNotEqualTo(Integer value) {
            addCriterion("cultural_level <>", value, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelGreaterThan(Integer value) {
            addCriterion("cultural_level >", value, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelGreaterThanOrEqualTo(Integer value) {
            addCriterion("cultural_level >=", value, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelLessThan(Integer value) {
            addCriterion("cultural_level <", value, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelLessThanOrEqualTo(Integer value) {
            addCriterion("cultural_level <=", value, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelIn(List<Integer> values) {
            addCriterion("cultural_level in", values, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelNotIn(List<Integer> values) {
            addCriterion("cultural_level not in", values, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelBetween(Integer value1, Integer value2) {
            addCriterion("cultural_level between", value1, value2, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andCulturalLevelNotBetween(Integer value1, Integer value2) {
            addCriterion("cultural_level not between", value1, value2, "culturalLevel");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleIsNull() {
            addCriterion("technical_title is null");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleIsNotNull() {
            addCriterion("technical_title is not null");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleEqualTo(String value) {
            addCriterion("technical_title =", value, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleNotEqualTo(String value) {
            addCriterion("technical_title <>", value, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleGreaterThan(String value) {
            addCriterion("technical_title >", value, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleGreaterThanOrEqualTo(String value) {
            addCriterion("technical_title >=", value, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleLessThan(String value) {
            addCriterion("technical_title <", value, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleLessThanOrEqualTo(String value) {
            addCriterion("technical_title <=", value, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleLike(String value) {
            addCriterion("technical_title like", value, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleNotLike(String value) {
            addCriterion("technical_title not like", value, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleIn(List<String> values) {
            addCriterion("technical_title in", values, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleNotIn(List<String> values) {
            addCriterion("technical_title not in", values, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleBetween(String value1, String value2) {
            addCriterion("technical_title between", value1, value2, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andTechnicalTitleNotBetween(String value1, String value2) {
            addCriterion("technical_title not between", value1, value2, "technicalTitle");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeIsNull() {
            addCriterion("staff_status_code is null");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeIsNotNull() {
            addCriterion("staff_status_code is not null");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeEqualTo(Integer value) {
            addCriterion("staff_status_code =", value, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeNotEqualTo(Integer value) {
            addCriterion("staff_status_code <>", value, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeGreaterThan(Integer value) {
            addCriterion("staff_status_code >", value, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("staff_status_code >=", value, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeLessThan(Integer value) {
            addCriterion("staff_status_code <", value, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeLessThanOrEqualTo(Integer value) {
            addCriterion("staff_status_code <=", value, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeIn(List<Integer> values) {
            addCriterion("staff_status_code in", values, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeNotIn(List<Integer> values) {
            addCriterion("staff_status_code not in", values, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeBetween(Integer value1, Integer value2) {
            addCriterion("staff_status_code between", value1, value2, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffStatusCodeNotBetween(Integer value1, Integer value2) {
            addCriterion("staff_status_code not between", value1, value2, "staffStatusCode");
            return (Criteria) this;
        }

        public Criteria andStaffpicIsNull() {
            addCriterion("staffpic is null");
            return (Criteria) this;
        }

        public Criteria andStaffpicIsNotNull() {
            addCriterion("staffpic is not null");
            return (Criteria) this;
        }

        public Criteria andStaffpicEqualTo(String value) {
            addCriterion("staffpic =", value, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicNotEqualTo(String value) {
            addCriterion("staffpic <>", value, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicGreaterThan(String value) {
            addCriterion("staffpic >", value, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicGreaterThanOrEqualTo(String value) {
            addCriterion("staffpic >=", value, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicLessThan(String value) {
            addCriterion("staffpic <", value, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicLessThanOrEqualTo(String value) {
            addCriterion("staffpic <=", value, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicLike(String value) {
            addCriterion("staffpic like", value, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicNotLike(String value) {
            addCriterion("staffpic not like", value, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicIn(List<String> values) {
            addCriterion("staffpic in", values, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicNotIn(List<String> values) {
            addCriterion("staffpic not in", values, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicBetween(String value1, String value2) {
            addCriterion("staffpic between", value1, value2, "staffpic");
            return (Criteria) this;
        }

        public Criteria andStaffpicNotBetween(String value1, String value2) {
            addCriterion("staffpic not between", value1, value2, "staffpic");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeIsNull() {
            addCriterion("domicile_code is null");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeIsNotNull() {
            addCriterion("domicile_code is not null");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeEqualTo(Integer value) {
            addCriterion("domicile_code =", value, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeNotEqualTo(Integer value) {
            addCriterion("domicile_code <>", value, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeGreaterThan(Integer value) {
            addCriterion("domicile_code >", value, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("domicile_code >=", value, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeLessThan(Integer value) {
            addCriterion("domicile_code <", value, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeLessThanOrEqualTo(Integer value) {
            addCriterion("domicile_code <=", value, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeIn(List<Integer> values) {
            addCriterion("domicile_code in", values, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeNotIn(List<Integer> values) {
            addCriterion("domicile_code not in", values, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeBetween(Integer value1, Integer value2) {
            addCriterion("domicile_code between", value1, value2, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andDomicileCodeNotBetween(Integer value1, Integer value2) {
            addCriterion("domicile_code not between", value1, value2, "domicileCode");
            return (Criteria) this;
        }

        public Criteria andBorndateIsNull() {
            addCriterion("borndate is null");
            return (Criteria) this;
        }

        public Criteria andBorndateIsNotNull() {
            addCriterion("borndate is not null");
            return (Criteria) this;
        }

        public Criteria andBorndateEqualTo(Date value) {
            addCriterion("borndate =", value, "borndate");
            return (Criteria) this;
        }

        public Criteria andBorndateNotEqualTo(Date value) {
            addCriterion("borndate <>", value, "borndate");
            return (Criteria) this;
        }

        public Criteria andBorndateGreaterThan(Date value) {
            addCriterion("borndate >", value, "borndate");
            return (Criteria) this;
        }

        public Criteria andBorndateGreaterThanOrEqualTo(Date value) {
            addCriterion("borndate >=", value, "borndate");
            return (Criteria) this;
        }

        public Criteria andBorndateLessThan(Date value) {
            addCriterion("borndate <", value, "borndate");
            return (Criteria) this;
        }

        public Criteria andBorndateLessThanOrEqualTo(Date value) {
            addCriterion("borndate <=", value, "borndate");
            return (Criteria) this;
        }

        public Criteria andBorndateIn(List<Date> values) {
            addCriterion("borndate in", values, "borndate");
            return (Criteria) this;
        }

        public Criteria andBorndateNotIn(List<Date> values) {
            addCriterion("borndate not in", values, "borndate");
            return (Criteria) this;
        }

        public Criteria andBorndateBetween(Date value1, Date value2) {
            addCriterion("borndate between", value1, value2, "borndate");
            return (Criteria) this;
        }

        public Criteria andBorndateNotBetween(Date value1, Date value2) {
            addCriterion("borndate not between", value1, value2, "borndate");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeIsNull() {
            addCriterion("work_type_code is null");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeIsNotNull() {
            addCriterion("work_type_code is not null");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeEqualTo(Integer value) {
            addCriterion("work_type_code =", value, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeNotEqualTo(Integer value) {
            addCriterion("work_type_code <>", value, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeGreaterThan(Integer value) {
            addCriterion("work_type_code >", value, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("work_type_code >=", value, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeLessThan(Integer value) {
            addCriterion("work_type_code <", value, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeLessThanOrEqualTo(Integer value) {
            addCriterion("work_type_code <=", value, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeIn(List<Integer> values) {
            addCriterion("work_type_code in", values, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeNotIn(List<Integer> values) {
            addCriterion("work_type_code not in", values, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeBetween(Integer value1, Integer value2) {
            addCriterion("work_type_code between", value1, value2, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andWorkTypeCodeNotBetween(Integer value1, Integer value2) {
            addCriterion("work_type_code not between", value1, value2, "workTypeCode");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateIsNull() {
            addCriterion("certificate_first_issuedate is null");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateIsNotNull() {
            addCriterion("certificate_first_issuedate is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateEqualTo(Date value) {
            addCriterion("certificate_first_issuedate =", value, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateNotEqualTo(Date value) {
            addCriterion("certificate_first_issuedate <>", value, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateGreaterThan(Date value) {
            addCriterion("certificate_first_issuedate >", value, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateGreaterThanOrEqualTo(Date value) {
            addCriterion("certificate_first_issuedate >=", value, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateLessThan(Date value) {
            addCriterion("certificate_first_issuedate <", value, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateLessThanOrEqualTo(Date value) {
            addCriterion("certificate_first_issuedate <=", value, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateIn(List<Date> values) {
            addCriterion("certificate_first_issuedate in", values, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateNotIn(List<Date> values) {
            addCriterion("certificate_first_issuedate not in", values, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateBetween(Date value1, Date value2) {
            addCriterion("certificate_first_issuedate between", value1, value2, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateFirstIssuedateNotBetween(Date value1, Date value2) {
            addCriterion("certificate_first_issuedate not between", value1, value2, "certificateFirstIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateIsNull() {
            addCriterion("certificate_issuedate is null");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateIsNotNull() {
            addCriterion("certificate_issuedate is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateEqualTo(Date value) {
            addCriterion("certificate_issuedate =", value, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateNotEqualTo(Date value) {
            addCriterion("certificate_issuedate <>", value, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateGreaterThan(Date value) {
            addCriterion("certificate_issuedate >", value, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateGreaterThanOrEqualTo(Date value) {
            addCriterion("certificate_issuedate >=", value, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateLessThan(Date value) {
            addCriterion("certificate_issuedate <", value, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateLessThanOrEqualTo(Date value) {
            addCriterion("certificate_issuedate <=", value, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateIn(List<Date> values) {
            addCriterion("certificate_issuedate in", values, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateNotIn(List<Date> values) {
            addCriterion("certificate_issuedate not in", values, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateBetween(Date value1, Date value2) {
            addCriterion("certificate_issuedate between", value1, value2, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateIssuedateNotBetween(Date value1, Date value2) {
            addCriterion("certificate_issuedate not between", value1, value2, "certificateIssuedate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateIsNull() {
            addCriterion("certificate_expiredate is null");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateIsNotNull() {
            addCriterion("certificate_expiredate is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateEqualTo(Date value) {
            addCriterion("certificate_expiredate =", value, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateNotEqualTo(Date value) {
            addCriterion("certificate_expiredate <>", value, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateGreaterThan(Date value) {
            addCriterion("certificate_expiredate >", value, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateGreaterThanOrEqualTo(Date value) {
            addCriterion("certificate_expiredate >=", value, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateLessThan(Date value) {
            addCriterion("certificate_expiredate <", value, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateLessThanOrEqualTo(Date value) {
            addCriterion("certificate_expiredate <=", value, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateIn(List<Date> values) {
            addCriterion("certificate_expiredate in", values, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateNotIn(List<Date> values) {
            addCriterion("certificate_expiredate not in", values, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateBetween(Date value1, Date value2) {
            addCriterion("certificate_expiredate between", value1, value2, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andCertificateExpiredateNotBetween(Date value1, Date value2) {
            addCriterion("certificate_expiredate not between", value1, value2, "certificateExpiredate");
            return (Criteria) this;
        }

        public Criteria andIssueOrganIsNull() {
            addCriterion("issue_organ is null");
            return (Criteria) this;
        }

        public Criteria andIssueOrganIsNotNull() {
            addCriterion("issue_organ is not null");
            return (Criteria) this;
        }

        public Criteria andIssueOrganEqualTo(String value) {
            addCriterion("issue_organ =", value, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganNotEqualTo(String value) {
            addCriterion("issue_organ <>", value, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganGreaterThan(String value) {
            addCriterion("issue_organ >", value, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganGreaterThanOrEqualTo(String value) {
            addCriterion("issue_organ >=", value, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLessThan(String value) {
            addCriterion("issue_organ <", value, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLessThanOrEqualTo(String value) {
            addCriterion("issue_organ <=", value, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLike(String value) {
            addCriterion("issue_organ like", value, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganNotLike(String value) {
            addCriterion("issue_organ not like", value, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganIn(List<String> values) {
            addCriterion("issue_organ in", values, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganNotIn(List<String> values) {
            addCriterion("issue_organ not in", values, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganBetween(String value1, String value2) {
            addCriterion("issue_organ between", value1, value2, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganNotBetween(String value1, String value2) {
            addCriterion("issue_organ not between", value1, value2, "issueOrgan");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeIsNull() {
            addCriterion("issue_organ_loccode is null");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeIsNotNull() {
            addCriterion("issue_organ_loccode is not null");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeEqualTo(Integer value) {
            addCriterion("issue_organ_loccode =", value, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeNotEqualTo(Integer value) {
            addCriterion("issue_organ_loccode <>", value, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeGreaterThan(Integer value) {
            addCriterion("issue_organ_loccode >", value, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("issue_organ_loccode >=", value, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeLessThan(Integer value) {
            addCriterion("issue_organ_loccode <", value, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeLessThanOrEqualTo(Integer value) {
            addCriterion("issue_organ_loccode <=", value, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeIn(List<Integer> values) {
            addCriterion("issue_organ_loccode in", values, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeNotIn(List<Integer> values) {
            addCriterion("issue_organ_loccode not in", values, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeBetween(Integer value1, Integer value2) {
            addCriterion("issue_organ_loccode between", value1, value2, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganLoccodeNotBetween(Integer value1, Integer value2) {
            addCriterion("issue_organ_loccode not between", value1, value2, "issueOrganLoccode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeIsNull() {
            addCriterion("issue_organ_code is null");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeIsNotNull() {
            addCriterion("issue_organ_code is not null");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeEqualTo(Integer value) {
            addCriterion("issue_organ_code =", value, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeNotEqualTo(Integer value) {
            addCriterion("issue_organ_code <>", value, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeGreaterThan(Integer value) {
            addCriterion("issue_organ_code >", value, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("issue_organ_code >=", value, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeLessThan(Integer value) {
            addCriterion("issue_organ_code <", value, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeLessThanOrEqualTo(Integer value) {
            addCriterion("issue_organ_code <=", value, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeIn(List<Integer> values) {
            addCriterion("issue_organ_code in", values, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeNotIn(List<Integer> values) {
            addCriterion("issue_organ_code not in", values, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeBetween(Integer value1, Integer value2) {
            addCriterion("issue_organ_code between", value1, value2, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andIssueOrganCodeNotBetween(Integer value1, Integer value2) {
            addCriterion("issue_organ_code not between", value1, value2, "issueOrganCode");
            return (Criteria) this;
        }

        public Criteria andCertificateStateIsNull() {
            addCriterion("certificate_state is null");
            return (Criteria) this;
        }

        public Criteria andCertificateStateIsNotNull() {
            addCriterion("certificate_state is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateStateEqualTo(Date value) {
            addCriterion("certificate_state =", value, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateStateNotEqualTo(Date value) {
            addCriterion("certificate_state <>", value, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateStateGreaterThan(Date value) {
            addCriterion("certificate_state >", value, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateStateGreaterThanOrEqualTo(Date value) {
            addCriterion("certificate_state >=", value, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateStateLessThan(Date value) {
            addCriterion("certificate_state <", value, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateStateLessThanOrEqualTo(Date value) {
            addCriterion("certificate_state <=", value, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateStateIn(List<Date> values) {
            addCriterion("certificate_state in", values, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateStateNotIn(List<Date> values) {
            addCriterion("certificate_state not in", values, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateStateBetween(Date value1, Date value2) {
            addCriterion("certificate_state between", value1, value2, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateStateNotBetween(Date value1, Date value2) {
            addCriterion("certificate_state not between", value1, value2, "certificateState");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeIsNull() {
            addCriterion("certificate_type is null");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeIsNotNull() {
            addCriterion("certificate_type is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeEqualTo(Integer value) {
            addCriterion("certificate_type =", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotEqualTo(Integer value) {
            addCriterion("certificate_type <>", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeGreaterThan(Integer value) {
            addCriterion("certificate_type >", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("certificate_type >=", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeLessThan(Integer value) {
            addCriterion("certificate_type <", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeLessThanOrEqualTo(Integer value) {
            addCriterion("certificate_type <=", value, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeIn(List<Integer> values) {
            addCriterion("certificate_type in", values, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotIn(List<Integer> values) {
            addCriterion("certificate_type not in", values, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeBetween(Integer value1, Integer value2) {
            addCriterion("certificate_type between", value1, value2, "certificateType");
            return (Criteria) this;
        }

        public Criteria andCertificateTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("certificate_type not between", value1, value2, "certificateType");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicIsNull() {
            addCriterion("iccard_certificate_codeic is null");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicIsNotNull() {
            addCriterion("iccard_certificate_codeic is not null");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicEqualTo(Integer value) {
            addCriterion("iccard_certificate_codeic =", value, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicNotEqualTo(Integer value) {
            addCriterion("iccard_certificate_codeic <>", value, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicGreaterThan(Integer value) {
            addCriterion("iccard_certificate_codeic >", value, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicGreaterThanOrEqualTo(Integer value) {
            addCriterion("iccard_certificate_codeic >=", value, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicLessThan(Integer value) {
            addCriterion("iccard_certificate_codeic <", value, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicLessThanOrEqualTo(Integer value) {
            addCriterion("iccard_certificate_codeic <=", value, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicIn(List<Integer> values) {
            addCriterion("iccard_certificate_codeic in", values, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicNotIn(List<Integer> values) {
            addCriterion("iccard_certificate_codeic not in", values, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicBetween(Integer value1, Integer value2) {
            addCriterion("iccard_certificate_codeic between", value1, value2, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andIccardCertificateCodeicNotBetween(Integer value1, Integer value2) {
            addCriterion("iccard_certificate_codeic not between", value1, value2, "iccardCertificateCodeic");
            return (Criteria) this;
        }

        public Criteria andBusiTypeIsNull() {
            addCriterion("busi_type is null");
            return (Criteria) this;
        }

        public Criteria andBusiTypeIsNotNull() {
            addCriterion("busi_type is not null");
            return (Criteria) this;
        }

        public Criteria andBusiTypeEqualTo(Integer value) {
            addCriterion("busi_type =", value, "busiType");
            return (Criteria) this;
        }

        public Criteria andBusiTypeNotEqualTo(Integer value) {
            addCriterion("busi_type <>", value, "busiType");
            return (Criteria) this;
        }

        public Criteria andBusiTypeGreaterThan(Integer value) {
            addCriterion("busi_type >", value, "busiType");
            return (Criteria) this;
        }

        public Criteria andBusiTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("busi_type >=", value, "busiType");
            return (Criteria) this;
        }

        public Criteria andBusiTypeLessThan(Integer value) {
            addCriterion("busi_type <", value, "busiType");
            return (Criteria) this;
        }

        public Criteria andBusiTypeLessThanOrEqualTo(Integer value) {
            addCriterion("busi_type <=", value, "busiType");
            return (Criteria) this;
        }

        public Criteria andBusiTypeIn(List<Integer> values) {
            addCriterion("busi_type in", values, "busiType");
            return (Criteria) this;
        }

        public Criteria andBusiTypeNotIn(List<Integer> values) {
            addCriterion("busi_type not in", values, "busiType");
            return (Criteria) this;
        }

        public Criteria andBusiTypeBetween(Integer value1, Integer value2) {
            addCriterion("busi_type between", value1, value2, "busiType");
            return (Criteria) this;
        }

        public Criteria andBusiTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("busi_type not between", value1, value2, "busiType");
            return (Criteria) this;
        }

        public Criteria andClientCodeIsNull() {
            addCriterion("client_code is null");
            return (Criteria) this;
        }

        public Criteria andClientCodeIsNotNull() {
            addCriterion("client_code is not null");
            return (Criteria) this;
        }

        public Criteria andClientCodeEqualTo(Integer value) {
            addCriterion("client_code =", value, "clientCode");
            return (Criteria) this;
        }

        public Criteria andClientCodeNotEqualTo(Integer value) {
            addCriterion("client_code <>", value, "clientCode");
            return (Criteria) this;
        }

        public Criteria andClientCodeGreaterThan(Integer value) {
            addCriterion("client_code >", value, "clientCode");
            return (Criteria) this;
        }

        public Criteria andClientCodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("client_code >=", value, "clientCode");
            return (Criteria) this;
        }

        public Criteria andClientCodeLessThan(Integer value) {
            addCriterion("client_code <", value, "clientCode");
            return (Criteria) this;
        }

        public Criteria andClientCodeLessThanOrEqualTo(Integer value) {
            addCriterion("client_code <=", value, "clientCode");
            return (Criteria) this;
        }

        public Criteria andClientCodeIn(List<Integer> values) {
            addCriterion("client_code in", values, "clientCode");
            return (Criteria) this;
        }

        public Criteria andClientCodeNotIn(List<Integer> values) {
            addCriterion("client_code not in", values, "clientCode");
            return (Criteria) this;
        }

        public Criteria andClientCodeBetween(Integer value1, Integer value2) {
            addCriterion("client_code between", value1, value2, "clientCode");
            return (Criteria) this;
        }

        public Criteria andClientCodeNotBetween(Integer value1, Integer value2) {
            addCriterion("client_code not between", value1, value2, "clientCode");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andIdcardIsNull() {
            addCriterion("idcard is null");
            return (Criteria) this;
        }

        public Criteria andIdcardIsNotNull() {
            addCriterion("idcard is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardEqualTo(String value) {
            addCriterion("idcard =", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotEqualTo(String value) {
            addCriterion("idcard <>", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardGreaterThan(String value) {
            addCriterion("idcard >", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardGreaterThanOrEqualTo(String value) {
            addCriterion("idcard >=", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLessThan(String value) {
            addCriterion("idcard <", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLessThanOrEqualTo(String value) {
            addCriterion("idcard <=", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardLike(String value) {
            addCriterion("idcard like", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotLike(String value) {
            addCriterion("idcard not like", value, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardIn(List<String> values) {
            addCriterion("idcard in", values, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotIn(List<String> values) {
            addCriterion("idcard not in", values, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardBetween(String value1, String value2) {
            addCriterion("idcard between", value1, value2, "idcard");
            return (Criteria) this;
        }

        public Criteria andIdcardNotBetween(String value1, String value2) {
            addCriterion("idcard not between", value1, value2, "idcard");
            return (Criteria) this;
        }

        public Criteria andStaffStatusIsNull() {
            addCriterion("staff_status is null");
            return (Criteria) this;
        }

        public Criteria andStaffStatusIsNotNull() {
            addCriterion("staff_status is not null");
            return (Criteria) this;
        }

        public Criteria andStaffStatusEqualTo(String value) {
            addCriterion("staff_status =", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusNotEqualTo(String value) {
            addCriterion("staff_status <>", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusGreaterThan(String value) {
            addCriterion("staff_status >", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusGreaterThanOrEqualTo(String value) {
            addCriterion("staff_status >=", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusLessThan(String value) {
            addCriterion("staff_status <", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusLessThanOrEqualTo(String value) {
            addCriterion("staff_status <=", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusLike(String value) {
            addCriterion("staff_status like", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusNotLike(String value) {
            addCriterion("staff_status not like", value, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusIn(List<String> values) {
            addCriterion("staff_status in", values, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusNotIn(List<String> values) {
            addCriterion("staff_status not in", values, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusBetween(String value1, String value2) {
            addCriterion("staff_status between", value1, value2, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andStaffStatusNotBetween(String value1, String value2) {
            addCriterion("staff_status not between", value1, value2, "staffStatus");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeIsNull() {
            addCriterion("admdivcode is null");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeIsNotNull() {
            addCriterion("admdivcode is not null");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeEqualTo(Integer value) {
            addCriterion("admdivcode =", value, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeNotEqualTo(Integer value) {
            addCriterion("admdivcode <>", value, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeGreaterThan(Integer value) {
            addCriterion("admdivcode >", value, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeGreaterThanOrEqualTo(Integer value) {
            addCriterion("admdivcode >=", value, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeLessThan(Integer value) {
            addCriterion("admdivcode <", value, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeLessThanOrEqualTo(Integer value) {
            addCriterion("admdivcode <=", value, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeIn(List<Integer> values) {
            addCriterion("admdivcode in", values, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeNotIn(List<Integer> values) {
            addCriterion("admdivcode not in", values, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeBetween(Integer value1, Integer value2) {
            addCriterion("admdivcode between", value1, value2, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andAdmdivcodeNotBetween(Integer value1, Integer value2) {
            addCriterion("admdivcode not between", value1, value2, "admdivcode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeIsNull() {
            addCriterion("certificate_code is null");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeIsNotNull() {
            addCriterion("certificate_code is not null");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeEqualTo(String value) {
            addCriterion("certificate_code =", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotEqualTo(String value) {
            addCriterion("certificate_code <>", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeGreaterThan(String value) {
            addCriterion("certificate_code >", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeGreaterThanOrEqualTo(String value) {
            addCriterion("certificate_code >=", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeLessThan(String value) {
            addCriterion("certificate_code <", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeLessThanOrEqualTo(String value) {
            addCriterion("certificate_code <=", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeLike(String value) {
            addCriterion("certificate_code like", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotLike(String value) {
            addCriterion("certificate_code not like", value, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeIn(List<String> values) {
            addCriterion("certificate_code in", values, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotIn(List<String> values) {
            addCriterion("certificate_code not in", values, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeBetween(String value1, String value2) {
            addCriterion("certificate_code between", value1, value2, "certificateCode");
            return (Criteria) this;
        }

        public Criteria andCertificateCodeNotBetween(String value1, String value2) {
            addCriterion("certificate_code not between", value1, value2, "certificateCode");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}